﻿CREATE TABLE [dbo].[PromedioPeriodo] (
    [IdEstudiante] INT          NOT NULL,
    [IdPeriodo]    INT          NOT NULL,
    [Promedio]     DECIMAL (18) NOT NULL,
    CONSTRAINT [PK_PromedioPeriodo] PRIMARY KEY CLUSTERED ([IdEstudiante] ASC, [IdPeriodo] ASC),
    CONSTRAINT [FK_PromedioPeriodo_Periodo] FOREIGN KEY ([IdPeriodo]) REFERENCES [dbo].[Periodo] ([IdPeriodo])
);

